Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CalendarID (FK)(PK) | A unique system assigned identifier for the Calendar. | ID_CLD | Identity | integer | CalendarLevel(CA_CLD_LV) |
CalendarLevelID (FK)(PK) | A unique system assigned identifier for the CalendarLevel. | ID_CLD_LV | Identity | integer | CalendarLevel(CA_CLD_LV) |
CalendarPeriodID (PK) | A unique system assigned identifier for this CalendarPeriod | ID_CLD_PRD | Identity | integer | |
StartDateTime | The date and time the CalendarPeriod begins | TS_SRT | AuditDateTime | datetime | |
EndDateTime | The date and time the CalendarPeriod ends. | TS_END | AuditDateTime | datetime | |
CalendarPeriodName | The name assigned to this calendar period for reporting and presentation purposes. | NM_CLD_PRD | Name | varchar(40) | |